﻿-- son - 02.07.2013 - thay doi do rong cua truong nhap lieu

alter table tbl_product_category_item
alter column category_title nvarchar(300)
go
alter table tbl_product_category_item
alter column category_meta_keyword nvarchar(500)
go
alter table tbl_product_category_item
alter column category_meta_description nvarchar(500)
go
alter table tbl_product_category_item
alter column category_desc_short nvarchar(500)
go
alter table tbl_product_category_item
alter column category_name nvarchar(300)
go
alter table tbl_product_category_item
alter column category_alias nvarchar(300)
go


alter table tbl_article_category_item
alter column category_title nvarchar(300)
go
alter table tbl_article_category_item
alter column category_meta_keyword nvarchar(500)
go
alter table tbl_article_category_item
alter column category_meta_description nvarchar(500)
go
alter table tbl_product_category_item
alter column category_desc_short nvarchar(500)
go
alter table tbl_product_category_item
alter column category_name nvarchar(300)
go
alter table tbl_product_category_item
alter column category_alias nvarchar(300)
go

alter table tbl_article_item
alter column title nvarchar(300)
go
alter table tbl_article_item
alter column alias nvarchar(300)
go
alter table tbl_article_item
alter column meta_key nvarchar(500)
go
alter table tbl_article_item
alter column meta_desc nvarchar(500)
go
alter table tbl_article_item
alter column intro_text nvarchar(500)
go

alter table tbl_product_item
alter column product_title nvarchar(300)
go
alter table tbl_product_item
alter column product_meta_keyword nvarchar(500)
go
alter table tbl_product_item
alter column product_meta_description nvarchar(500)
go
alter table tbl_product_item
alter column product_name nvarchar(300)
go
alter table tbl_product_item
alter column product_alias nvarchar(300)
go
alter table tbl_product_item
alter column product_desc_short nvarchar(500)
go

alter table tbl_product_category_item
alter column category_name nvarchar(300)
go
alter table tbl_product_category_item
alter column category_alias nvarchar(300)
go
alter table tbl_product_category_item
alter column category_desc_short nvarchar(300)
go

alter table tbl_article_category_item
alter column category_name nvarchar(300)
go
alter table tbl_article_category_item
alter column category_alias nvarchar(300)
go
alter table tbl_article_category_item
alter column category_desc_short nvarchar(300)
go


alter table tbl_email_template
alter column email_name nvarchar(200)
go
-- son - 02.07.2013 - thay doi do rong cua truong nhap lieu

alter table [tbl_web_link]
alter column [description] [nvarchar](500)
go